package com.rm.zeyou.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.rm.zeyou.entity.ShareConfig;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 分佣配置表 Mapper 接口
 * </p>
 *
 * @author YanYang
 * @since 2025-03-12 15:55:08
 */
@Mapper
public interface ShareConfigMapper extends BaseMapper<ShareConfig> {

    @Select("select value from t_share_config where code = 'salesman_split_rate' ")
    String getSalesmanSplitRate();

    @Select("select value from t_share_config where code = 'salesman_first_block_split_rate' ")
    String getSalesmanFirstBlockSplitRate();

    @Select("select value from t_share_config where code = 'salesman_second_block_split_rate' ")
    String getSalesmanSecondBlockSplitRate();

    @Select("select value from t_share_config where code = 'salesman_upgrade_split_rate' ")
    String getSalesmanUpgradeSplitRate();

    @Select("select value from t_share_config where code = 'channel_split_rate' ")
    String getChannelSplitRate();

    @Select("select value from t_share_config where code = 'channel_upgrade_split_rate' ")
    String getChannelUpgradeSplitRate();

    @Select("select value from t_share_config where code = 'channel_first_block_split_rate' ")
    String getChannelFirstBlockSplitRate();

    @Select("select value from t_share_config where code = 'channel_second_block_split_rate' ")
    String getChannelSecondBlockSplitRate();

    @Select("select value from t_share_config where code = 'broker_split_rate' ")
    String getBrokerSplitRate();

    @Select("select value from t_share_config where code = 'broker_upgrade_split_rate' ")
    String getBrokerUpgradeSplitRate();

    @Select("select value from t_share_config where code = 'broker_first_block_split_rate' ")
    String getBrokerFirstBlockSplitRate();

    @Select("select value from t_share_config where code = 'broker_second_block_split_rate' ")
    String getBrokerSecondBlockSplitRate();
}
